'''
Excel的表头更换成mysql的表字段
'''
# 学生招生数据
StudentData = {
    "性别": "sex",
    "考生类别": "studentType",
    "录取年级": "year",
    "院系名称": "college",
    "专业名称": "professional",
    "是否报道": "reported",
    "招生类别": "recruitType",
    "全国各省": "chinaProvince",
    "广东各市": "guangdongProvince"
}
need_cloumns=[
    ["考生类别","生源地","录取年级","院系名称","专业名称","是否报道","省份","招生类别"]
]

# 性格表
characterData = {"事务": "affair",
                 "操作": "operation",
                 "技能": "skill",
                 "规划": "plan",
                 "发明": "invention",
                 "艺术": "art",
                 "人文": "humanity",
                 "服务": "service",
                 "交际": "communication",
                 "影响": "influence",
                 "开括": "extension",
                 "管控": "control"
                 }

# 成绩表
achievementData = {
    "网页设计基础": "web_design",
    "应用数学（1）": "applied_mathematics_1",
    "程序设计基础": "fundamentals_of_programming",
    "数据库应用基础": "data_base",
    "应用数学（2）": "applied_mathematics_2",
    "Linux网络操作系统": "linux_system",
    "Python程序设计": "python_program",
    "Hadoop大数据技术": "hadoop_data"
}
#achievementData,applied_mathematics_1,fundamentals_of_programming,data_base,applied_mathematics_2,linux_system,python_program,hadoop_data

# 图书借阅数据
# 需要

bookData={
        "姓名":"stu_name",
        "专业":"professional",
        "财产号":"money_number",
        "书名":"book_name",
        "索书号":"book_index",
        "馆藏地":"book_hold"

}
